CREATE EXTERNAL TABLE `jms_ods`.`tab_bagbillcode_hi`(
  `bagcode` string COMMENT '包编号'
  , `billcode` string COMMENT '运单单号'
  , `subbillcode` string COMMENT '子单号'
  , `pcs` bigint COMMENT '件数'
  , `weight` double COMMENT '重量'
  , `scantime` timestamp COMMENT '扫描时间'
  , `inputtime` timestamp COMMENT '录入时间'
  , `scanuser` string COMMENT '扫描雇员'
  , `scanusercode` string COMMENT '扫描雇员编号'
  , `inputsite` string COMMENT '录入部门'
  , `scansitecode` string COMMENT '扫描网点编号')
COMMENT '袋运单子单表'
PARTITIONED BY (`dt` string COMMENT '更新日期 (yyyy-MM-dd HH)')
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
WITH SERDEPROPERTIES (
  'serialization.format' = '1'
)
STORED AS
  INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION '/dw/hive/jms_ods.db/external/tab_bagbillcode_hi';